Page 134 - 2629_Devagiri_C-8

2. The TIMESTAMP data type stores only hour, minute and second values.

3. Tableau cannot process data directly from cloud platforms.

4. Data science is only used for online shopping recommendations.

5. The ‘drive for’ block lets the robot move a specific distance.

6. The ‘set pen to color’ block can change the pen colour to red, yellow or green.

7. A while loop checks the condition after each repetition.

8. After a break statement is executed, control moves to the beginning of the loop again.

C. Fill in the blanks.
1. The command retrieves zero or more rows from a table.

2. The command is used to view a list of existing databases.
3. helps us to find patterns, trends and relationships in data.

4. refers to raw facts or figures collected for analysis.

5. The sensor detects the colour of the surface below the robot.
6. The block sets the speed (percent) for forward and reverse driving.

7. means repeating a set of instructions again and again.
8. An loop never ends because its condition is always true and never becomes false.

D. Answer the following questions:
1. Differentiate between primary key and foreign key.

2. Explain the use of Where clause in SQL.
3. Differentiate between structured and unstructured data.

4. What is Tableau and why is it used?

5. Describe the Distance Sensing blocks.
6. List any two Drivetrain blocks in VEXcode VR.

7. Explain the difference between a for loop and a while loop.
8. Describe an infinite loop.

132
Premium Edition-VIII